Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 65241 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 10.5 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 7 |
DateKey has a high cardinality: 558 distinct values | High cardinality |
Invoice Date has a high cardinality: 558 distinct values | High cardinality |
Item Number has a high cardinality: 983 distinct values | High cardinality |
Item has a high cardinality: 650 distinct values | High cardinality |
Promised Delivery Date has a high cardinality: 590 distinct values | High cardinality |
Discount Amount is highly overall correlated with Sales Amount and 3 other fields | High correlation |
List Price is highly overall correlated with Sales Price and 1 other fields | High correlation |
Sales Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Amount Based on List Price is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Cost Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Margin Amount is highly overall correlated with Discount Amount and 3 other fields | High correlation |
Sales Price is highly overall correlated with List Price and 1 other fields | High correlation |
Sales Quantity is highly overall correlated with List Price and 1 other fields | High correlation |
Item Class is highly imbalanced (99.7%) | Imbalance |
U/M is highly imbalanced (68.2%) | Imbalance |
Sales Cost Amount is highly skewed (γ1 = 21.0046152) | Skewed |
Sales Quantity is highly skewed (γ1 = 23.00067352) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Discount Amount has 1214 (1.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-01-21 08:05:36.744951 |
|---|---|
| Analysis finished | 2023-01-21 08:06:35.162081 |
| Duration | 58.42 seconds |
| Software version | pandas-profiling vv3.6.2 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
UNIFORM  UNIQUE 
| Distinct | 65241 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32649.053 |
| Minimum | 1 |
|---|---|
| Maximum | 65281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3276 |
| Q1 | 16324 |
| median | 32654 |
| Q3 | 48970 |
| 95-th percentile | 62019 |
| Maximum | 65281 |
| Range | 65280 |
| Interquartile range (IQR) | 32646 |
Descriptive statistics
| Standard deviation | 18844.646 |
|---|---|
| Coefficient of variation (CV) | 0.57718813 |
| Kurtosis | -1.2005117 |
| Mean | 32649.053 |
| Median Absolute Deviation (MAD) | 16323 |
| Skewness | -0.00023741259 |
| Sum | 2.1300569 × 109 |
| Variance | 3.5512067 × 108 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 43539 | 1 | < 0.1% |
| 43526 | 1 | < 0.1% |
| 43527 | 1 | < 0.1% |
| 43528 | 1 | < 0.1% |
| 43529 | 1 | < 0.1% |
| 43530 | 1 | < 0.1% |
| 43531 | 1 | < 0.1% |
| 43532 | 1 | < 0.1% |
| 43533 | 1 | < 0.1% |
| Other values (65231) | 65231 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 4 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 65281 | 1 | |
| 65280 | 1 | |
| 65279 | 1 | |
| 65278 | 1 | |
| 65277 | 1 | |
| 65276 | 1 | |
| 65275 | 1 | |
| 65274 | 1 | |
| 65273 | 1 | |
| 65272 | 1 |
CustKey
Real number (ℝ)
| Distinct | 615 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10017703 |
| Minimum | 10000453 |
|---|---|
| Maximum | 10027583 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 10000453 |
|---|---|
| 5-th percentile | 10002506 |
| Q1 | 10012715 |
| median | 10019665 |
| Q3 | 10023511 |
| 95-th percentile | 10026006 |
| Maximum | 10027583 |
| Range | 27130 |
| Interquartile range (IQR) | 10796 |
Descriptive statistics
| Standard deviation | 7175.8459 |
|---|---|
| Coefficient of variation (CV) | 0.00071631648 |
| Kurtosis | -0.37098298 |
| Mean | 10017703 |
| Median Absolute Deviation (MAD) | 4886 |
| Skewness | -0.77030273 |
| Sum | 6.5356497 × 1011 |
| Variance | 51492764 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10025919 | 2760 | 4.2% |
| 10019194 | 2752 | 4.2% |
| 10012715 | 1431 | 2.2% |
| 10012226 | 1389 | 2.1% |
| 10025025 | 1143 | 1.8% |
| 10023524 | 1042 | 1.6% |
| 10020515 | 1010 | 1.5% |
| 10017638 | 790 | 1.2% |
| 10022456 | 741 | 1.1% |
| 10002506 | 714 | 1.1% |
| Other values (605) | 51469 |
| Value | Count | Frequency (%) |
| 10000453 | 329 | |
| 10000455 | 19 | < 0.1% |
| 10000456 | 104 | 0.2% |
| 10000457 | 19 | < 0.1% |
| 10000458 | 10 | < 0.1% |
| 10000460 | 120 | 0.2% |
| 10000461 | 251 | |
| 10000462 | 3 | < 0.1% |
| 10000466 | 123 | 0.2% |
| 10000469 | 162 |
| Value | Count | Frequency (%) |
| 10027583 | 25 | < 0.1% |
| 10027575 | 5 | < 0.1% |
| 10027572 | 52 | 0.1% |
| 10027560 | 42 | 0.1% |
| 10027381 | 108 | |
| 10027370 | 234 | |
| 10027356 | 21 | < 0.1% |
| 10027348 | 14 | < 0.1% |
| 10027340 | 35 | 0.1% |
| 10027119 | 175 |
DateKey
Categorical
| Distinct | 558 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| 23/06/2017 | 460 |
|---|---|
| 05/07/2019 | 447 |
| 27/06/2017 | 313 |
| 18/11/2017 | 313 |
| 11/01/2017 | 310 |
| Other values (553) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 652410 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 14/07/2017 |
|---|---|
| 2nd row | 17/10/2017 |
| 3rd row | 27/05/2017 |
| 4th row | 03/09/2017 |
| 5th row | 18/06/2017 |
Common Values
| Value | Count | Frequency (%) |
| 23/06/2017 | 460 | 0.7% |
| 05/07/2019 | 447 | 0.7% |
| 27/06/2017 | 313 | 0.5% |
| 18/11/2017 | 313 | 0.5% |
| 11/01/2017 | 310 | 0.5% |
| 09/07/2019 | 307 | 0.5% |
| 30/11/2019 | 307 | 0.5% |
| 26/06/2017 | 294 | 0.5% |
| 08/07/2019 | 279 | 0.4% |
| 29/04/2017 | 279 | 0.4% |
| Other values (548) | 61932 |
Length
| Value | Count | Frequency (%) |
| 23/06/2017 | 460 | 0.7% |
| 05/07/2019 | 447 | 0.7% |
| 27/06/2017 | 313 | 0.5% |
| 18/11/2017 | 313 | 0.5% |
| 11/01/2017 | 310 | 0.5% |
| 09/07/2019 | 307 | 0.5% |
| 30/11/2019 | 307 | 0.5% |
| 26/06/2017 | 294 | 0.5% |
| 29/04/2017 | 279 | 0.4% |
| 08/07/2019 | 279 | 0.4% |
| Other values (548) | 61932 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 521928 | |
| Other Punctuation | 130482 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 7.9% |
| 9 | 40766 | 7.8% |
| 8 | 18237 | 3.5% |
| 3 | 16726 | 3.2% |
| 6 | 11652 | 2.2% |
| 5 | 11348 | 2.2% |
| 4 | 9620 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 130482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 652410 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 652410 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Discount Amount
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 17730 |
|---|---|
| Distinct (%) | 27.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1857.3109 |
| Minimum | -255820.8 |
|---|---|
| Maximum | 343532.66 |
| Zeros | 1214 |
| Zeros (%) | 1.9% |
| Negative | 933 |
| Negative (%) | 1.4% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | -255820.8 |
|---|---|
| 5-th percentile | 19.0422 |
| Q1 | 246.28 |
| median | 442.2 |
| Q3 | 1001.5 |
| 95-th percentile | 6354.225 |
| Maximum | 343532.66 |
| Range | 599353.46 |
| Interquartile range (IQR) | 755.22 |
Descriptive statistics
| Standard deviation | 9039.5358 |
|---|---|
| Coefficient of variation (CV) | 4.8670019 |
| Kurtosis | 379.55115 |
| Mean | 1857.3109 |
| Median Absolute Deviation (MAD) | 234.14 |
| Skewness | 10.83909 |
| Sum | 1.2117282 × 108 |
| Variance | 81713207 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1214 | 1.9% |
| 24.88 | 103 | 0.2% |
| 606.84 | 100 | 0.2% |
| 639.82 | 97 | 0.1% |
| 601.9033 | 93 | 0.1% |
| 634.6133 | 93 | 0.1% |
| 402.7 | 93 | 0.1% |
| 918.1412 | 88 | 0.1% |
| 169.36 | 87 | 0.1% |
| 385.98 | 87 | 0.1% |
| Other values (17720) | 63186 |
| Value | Count | Frequency (%) |
| -255820.8 | 1 | < 0.1% |
| -245587.97 | 1 | < 0.1% |
| -238792.73 | 1 | < 0.1% |
| -231837.6 | 3 | |
| -222564.1 | 3 | |
| -127176 | 1 | < 0.1% |
| -122088.96 | 1 | < 0.1% |
| -84573.72 | 1 | < 0.1% |
| -81190.77 | 1 | < 0.1% |
| -53626 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 343532.66 | 2 | |
| 339103.35 | 1 | < 0.1% |
| 331487.76 | 2 | |
| 327213.75 | 1 | < 0.1% |
| 322454.09 | 1 | < 0.1% |
| 210371 | 4 | |
| 202995 | 4 | |
| 191196.5532 | 2 | |
| 189333.9 | 1 | < 0.1% |
| 182832.8832 | 2 |
Invoice Date
Categorical
| Distinct | 558 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| 23/06/2017 | 460 |
|---|---|
| 05/07/2019 | 447 |
| 27/06/2017 | 313 |
| 18/11/2017 | 313 |
| 11/01/2017 | 310 |
| Other values (553) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 652410 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 14/07/2017 |
|---|---|
| 2nd row | 17/10/2017 |
| 3rd row | 27/05/2017 |
| 4th row | 03/09/2017 |
| 5th row | 18/06/2017 |
Common Values
| Value | Count | Frequency (%) |
| 23/06/2017 | 460 | 0.7% |
| 05/07/2019 | 447 | 0.7% |
| 27/06/2017 | 313 | 0.5% |
| 18/11/2017 | 313 | 0.5% |
| 11/01/2017 | 310 | 0.5% |
| 09/07/2019 | 307 | 0.5% |
| 30/11/2019 | 307 | 0.5% |
| 26/06/2017 | 294 | 0.5% |
| 08/07/2019 | 279 | 0.4% |
| 29/04/2017 | 279 | 0.4% |
| Other values (548) | 61932 |
Length
| Value | Count | Frequency (%) |
| 23/06/2017 | 460 | 0.7% |
| 05/07/2019 | 447 | 0.7% |
| 27/06/2017 | 313 | 0.5% |
| 18/11/2017 | 313 | 0.5% |
| 11/01/2017 | 310 | 0.5% |
| 09/07/2019 | 307 | 0.5% |
| 30/11/2019 | 307 | 0.5% |
| 26/06/2017 | 294 | 0.5% |
| 29/04/2017 | 279 | 0.4% |
| 08/07/2019 | 279 | 0.4% |
| Other values (548) | 61932 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 521928 | |
| Other Punctuation | 130482 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 7.9% |
| 9 | 40766 | 7.8% |
| 8 | 18237 | 3.5% |
| 3 | 16726 | 3.2% |
| 6 | 11652 | 2.2% |
| 5 | 11348 | 2.2% |
| 4 | 9620 | 1.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 130482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 652410 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 652410 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 144497 | |
| / | 130482 | |
| 1 | 122034 | |
| 2 | 105577 | |
| 7 | 41471 | 6.4% |
| 9 | 40766 | 6.2% |
| 8 | 18237 | 2.8% |
| 3 | 16726 | 2.6% |
| 6 | 11652 | 1.8% |
| 5 | 11348 | 1.7% |
Invoice Number
Real number (ℝ)
| Distinct | 24650 |
|---|---|
| Distinct (%) | 37.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 216292.79 |
| Minimum | 100034 |
|---|---|
| Maximum | 332842 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 100034 |
|---|---|
| 5-th percentile | 104168 |
| Q1 | 117969 |
| median | 222904 |
| Q3 | 314325 |
| 95-th percentile | 328904 |
| Maximum | 332842 |
| Range | 232808 |
| Interquartile range (IQR) | 196356 |
Descriptive statistics
| Standard deviation | 94982.019 |
|---|---|
| Coefficient of variation (CV) | 0.43913632 |
| Kurtosis | -1.8436257 |
| Mean | 216292.79 |
| Median Absolute Deviation (MAD) | 98209 |
| Skewness | 0.00055331482 |
| Sum | 1.4111158 × 1010 |
| Variance | 9.0215839 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 225396 | 103 | 0.2% |
| 113089 | 101 | 0.2% |
| 125396 | 101 | 0.2% |
| 126657 | 101 | 0.2% |
| 313089 | 100 | 0.2% |
| 325396 | 100 | 0.2% |
| 326657 | 100 | 0.2% |
| 129620 | 97 | 0.1% |
| 116099 | 97 | 0.1% |
| 316099 | 94 | 0.1% |
| Other values (24640) | 64247 |
| Value | Count | Frequency (%) |
| 100034 | 1 | |
| 100080 | 1 | |
| 100093 | 1 | |
| 100094 | 1 | |
| 100130 | 1 | |
| 100132 | 1 | |
| 100204 | 1 | |
| 100222 | 1 | |
| 100229 | 1 | |
| 100230 | 1 |
| Value | Count | Frequency (%) |
| 332842 | 1 | < 0.1% |
| 332840 | 3 | < 0.1% |
| 332837 | 14 | |
| 332831 | 3 | < 0.1% |
| 332828 | 3 | < 0.1% |
| 332826 | 1 | < 0.1% |
| 332823 | 3 | < 0.1% |
| 332821 | 6 | |
| 332820 | 1 | < 0.1% |
| 332818 | 1 | < 0.1% |
Item Class
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| P01 | |
|---|---|
| PO1 | 16 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 195723 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P01 |
|---|---|
| 2nd row | P01 |
| 3rd row | P01 |
| 4th row | P01 |
| 5th row | P01 |
Common Values
| Value | Count | Frequency (%) |
| P01 | 65225 | |
| PO1 | 16 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| p01 | 65225 | |
| po1 | 16 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 65241 | |
| 1 | 65241 | |
| 0 | 65225 | |
| O | 16 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 130466 | |
| Uppercase Letter | 65257 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 65241 | |
| O | 16 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 65241 | |
| 0 | 65225 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 130466 | |
| Latin | 65257 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 65241 | |
| O | 16 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 1 | 65241 | |
| 0 | 65225 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 195723 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 65241 | |
| 1 | 65241 | |
| 0 | 65225 | |
| O | 16 | < 0.1% |
Item Number
Categorical
| Distinct | 983 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| 17801 | 1610 |
|---|---|
| 28401 | 1344 |
| 27550 | 1182 |
| 67550 | 1126 |
| 20910 | 1050 |
| Other values (978) |
Length
| Max length | 25 |
|---|---|
| Median length | 5 |
| Mean length | 5.0427185 |
| Min length | 1 |
Characters and Unicode
| Total characters | 328992 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 20910 |
|---|---|
| 2nd row | 38076 |
| 3rd row | 60776 |
| 4th row | 20910 |
| 5th row | 62550 |
Common Values
| Value | Count | Frequency (%) |
| 17801 | 1610 | 2.5% |
| 28401 | 1344 | 2.1% |
| 27550 | 1182 | 1.8% |
| 67550 | 1126 | 1.7% |
| 20910 | 1050 | 1.6% |
| 11690 | 1045 | 1.6% |
| 47801 | 1043 | 1.6% |
| 36001 | 947 | 1.5% |
| 38076 | 942 | 1.4% |
| 26502 | 913 | 1.4% |
| Other values (973) | 54039 |
Length
| Value | Count | Frequency (%) |
| 17801 | 1610 | 2.5% |
| 28401 | 1344 | 2.1% |
| 27550 | 1182 | 1.8% |
| 67550 | 1126 | 1.7% |
| 20910 | 1050 | 1.6% |
| 11690 | 1045 | 1.6% |
| 47801 | 1043 | 1.6% |
| 36001 | 947 | 1.5% |
| 38076 | 942 | 1.4% |
| 26502 | 913 | 1.4% |
| Other values (982) | 54100 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 53332 | |
| 6 | 40050 | |
| 2 | 38591 | |
| 3 | 38533 | |
| 1 | 31241 | |
| 5 | 28577 | |
| 8 | 26759 | |
| 7 | 25335 | |
| 9 | 24277 | |
| 4 | 21437 | |
| Other values (28) | 860 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 328132 | |
| Uppercase Letter | 735 | 0.2% |
| Space Separator | 64 | < 0.1% |
| Dash Punctuation | 26 | < 0.1% |
| Other Punctuation | 25 | < 0.1% |
| Lowercase Letter | 7 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 259 | |
| A | 87 | 11.8% |
| R | 54 | 7.3% |
| S | 47 | 6.4% |
| E | 37 | 5.0% |
| I | 36 | 4.9% |
| Z | 35 | 4.8% |
| N | 34 | 4.6% |
| D | 33 | 4.5% |
| T | 28 | 3.8% |
| Other values (11) | 85 | 11.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 53332 | |
| 6 | 40050 | |
| 2 | 38591 | |
| 3 | 38533 | |
| 1 | 31241 | |
| 5 | 28577 | |
| 8 | 26759 | |
| 7 | 25335 | |
| 9 | 24277 | |
| 4 | 21437 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 23 | |
| # | 2 | 8.0% |
Space Separator
| Value | Count | Frequency (%) |
| 64 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 26 |
Lowercase Letter
| Value | Count | Frequency (%) |
| z | 7 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 328250 | |
| Latin | 742 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 259 | |
| A | 87 | 11.7% |
| R | 54 | 7.3% |
| S | 47 | 6.3% |
| E | 37 | 5.0% |
| I | 36 | 4.9% |
| Z | 35 | 4.7% |
| N | 34 | 4.6% |
| D | 33 | 4.4% |
| T | 28 | 3.8% |
| Other values (12) | 92 | 12.4% |
Common
| Value | Count | Frequency (%) |
| 0 | 53332 | |
| 6 | 40050 | |
| 2 | 38591 | |
| 3 | 38533 | |
| 1 | 31241 | |
| 5 | 28577 | |
| 8 | 26759 | |
| 7 | 25335 | |
| 9 | 24277 | |
| 4 | 21437 | |
| Other values (6) | 118 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 328992 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 53332 | |
| 6 | 40050 | |
| 2 | 38591 | |
| 3 | 38533 | |
| 1 | 31241 | |
| 5 | 28577 | |
| 8 | 26759 | |
| 7 | 25335 | |
| 9 | 24277 | |
| 4 | 21437 | |
| Other values (28) | 860 | 0.3% |
Item
Categorical
| Distinct | 650 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| Better Fancy Canned Sardines | 1648 |
|---|---|
| Ebony Prepared Salad | 1471 |
| Moms Sliced Turkey | 1192 |
| Imagine Popsicles | 1191 |
| Discover Manicotti | 1126 |
| Other values (645) |
Length
| Max length | 37 |
|---|---|
| Median length | 32 |
| Mean length | 21.722582 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1417203 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Moms Sliced Turkey |
|---|---|
| 2nd row | Cutting Edge Foot-Long Hot Dogs |
| 3rd row | High Top Sweet Onion |
| 4th row | Moms Sliced Turkey |
| 5th row | Tell Tale Garlic |
Common Values
| Value | Count | Frequency (%) |
| Better Fancy Canned Sardines | 1648 | 2.5% |
| Ebony Prepared Salad | 1471 | 2.3% |
| Moms Sliced Turkey | 1192 | 1.8% |
| Imagine Popsicles | 1191 | 1.8% |
| Discover Manicotti | 1126 | 1.7% |
| Red Spade Foot-Long Hot Dogs | 1075 | 1.6% |
| High Top Dried Mushrooms | 1072 | 1.6% |
| Big Time Frozen Cheese Pizza | 947 | 1.5% |
| Cutting Edge Foot-Long Hot Dogs | 942 | 1.4% |
| Bravo Large Canned Shrimp | 941 | 1.4% |
| Other values (640) | 53636 |
Length
| Value | Count | Frequency (%) |
| canned | 6375 | 2.8% |
| ebony | 5460 | 2.4% |
| cheese | 5192 | 2.3% |
| better | 4569 | 2.0% |
| red | 4271 | 1.9% |
| top | 4172 | 1.8% |
| spade | 4161 | 1.8% |
| high | 4137 | 1.8% |
| best | 3477 | 1.5% |
| nationeel | 3328 | 1.4% |
| Other values (294) | 184407 |
Most occurring characters
| Value | Count | Frequency (%) |
| 164308 | 11.6% | |
| e | 146997 | 10.4% |
| o | 92424 | 6.5% |
| a | 92229 | 6.5% |
| n | 74029 | 5.2% |
| i | 69406 | 4.9% |
| t | 68697 | 4.8% |
| r | 67309 | 4.7% |
| l | 59799 | 4.2% |
| s | 57763 | 4.1% |
| Other values (46) | 524242 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1013133 | |
| Uppercase Letter | 236106 | 16.7% |
| Space Separator | 164308 | 11.6% |
| Dash Punctuation | 2160 | 0.2% |
| Other Punctuation | 748 | 0.1% |
| Decimal Number | 748 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 146997 | |
| o | 92424 | 9.1% |
| a | 92229 | 9.1% |
| n | 74029 | 7.3% |
| i | 69406 | 6.9% |
| t | 68697 | 6.8% |
| r | 67309 | 6.6% |
| l | 59799 | 5.9% |
| s | 57763 | 5.7% |
| d | 40526 | 4.0% |
| Other values (16) | 243954 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 31413 | |
| C | 30848 | |
| S | 26119 | |
| T | 19360 | 8.2% |
| F | 16230 | 6.9% |
| M | 12512 | 5.3% |
| P | 11463 | 4.9% |
| L | 11018 | 4.7% |
| D | 10750 | 4.6% |
| E | 10232 | 4.3% |
| Other values (15) | 56161 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 579 | |
| 2 | 169 | 22.6% |
Space Separator
| Value | Count | Frequency (%) |
| 164308 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2160 |
Other Punctuation
| Value | Count | Frequency (%) |
| % | 748 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1249239 | |
| Common | 167964 | 11.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 146997 | 11.8% |
| o | 92424 | 7.4% |
| a | 92229 | 7.4% |
| n | 74029 | 5.9% |
| i | 69406 | 5.6% |
| t | 68697 | 5.5% |
| r | 67309 | 5.4% |
| l | 59799 | 4.8% |
| s | 57763 | 4.6% |
| d | 40526 | 3.2% |
| Other values (41) | 480060 |
Common
| Value | Count | Frequency (%) |
| 164308 | ||
| - | 2160 | 1.3% |
| % | 748 | 0.4% |
| 1 | 579 | 0.3% |
| 2 | 169 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1417203 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 164308 | 11.6% | |
| e | 146997 | 10.4% |
| o | 92424 | 6.5% |
| a | 92229 | 6.5% |
| n | 74029 | 5.2% |
| i | 69406 | 4.9% |
| t | 68697 | 4.8% |
| r | 67309 | 4.7% |
| l | 59799 | 4.2% |
| s | 57763 | 4.1% |
| Other values (46) | 524242 |
Line Number
Real number (ℝ)
| Distinct | 397 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23725.043 |
| Minimum | 1000 |
|---|---|
| Maximum | 344000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 3000 |
| median | 12000 |
| Q3 | 32000 |
| 95-th percentile | 88000 |
| Maximum | 344000 |
| Range | 343000 |
| Interquartile range (IQR) | 29000 |
Descriptive statistics
| Standard deviation | 32669.565 |
|---|---|
| Coefficient of variation (CV) | 1.3770076 |
| Kurtosis | 11.146323 |
| Mean | 23725.043 |
| Median Absolute Deviation (MAD) | 11000 |
| Skewness | 2.8814917 |
| Sum | 1.5478455 × 109 |
| Variance | 1.0673005 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1000 | 11189 | 17.2% |
| 2000 | 3696 | 5.7% |
| 3000 | 2763 | 4.2% |
| 4000 | 2287 | 3.5% |
| 5000 | 1947 | 3.0% |
| 6000 | 1839 | 2.8% |
| 9000 | 1614 | 2.5% |
| 7000 | 1586 | 2.4% |
| 8000 | 1464 | 2.2% |
| 10000 | 1412 | 2.2% |
| Other values (387) | 35444 |
| Value | Count | Frequency (%) |
| 1000 | 11189 | |
| 1001 | 247 | 0.4% |
| 1002 | 46 | 0.1% |
| 1003 | 5 | < 0.1% |
| 1100 | 4 | < 0.1% |
| 1101 | 4 | < 0.1% |
| 2000 | 3696 | 5.7% |
| 2001 | 158 | 0.2% |
| 2002 | 36 | 0.1% |
| 3000 | 2763 | 4.2% |
| Value | Count | Frequency (%) |
| 344000 | 2 | < 0.1% |
| 330000 | 2 | < 0.1% |
| 320000 | 2 | < 0.1% |
| 314001 | 2 | < 0.1% |
| 268000 | 2 | < 0.1% |
| 260000 | 2 | < 0.1% |
| 249000 | 2 | < 0.1% |
| 246000 | 2 | < 0.1% |
| 244000 | 2 | < 0.1% |
| 243000 | 7 |
List Price
Real number (ℝ)
| Distinct | 1062 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 515.01683 |
| Minimum | 0 |
|---|---|
| Maximum | 2760.7 |
| Zeros | 255 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36.69 |
| Q1 | 181.56 |
| median | 325.19 |
| Q3 | 803.86 |
| 95-th percentile | 1431.23 |
| Maximum | 2760.7 |
| Range | 2760.7 |
| Interquartile range (IQR) | 622.3 |
Descriptive statistics
| Standard deviation | 449.1449 |
|---|---|
| Coefficient of variation (CV) | 0.8720975 |
| Kurtosis | 0.011618476 |
| Mean | 515.01683 |
| Median Absolute Deviation (MAD) | 217.35 |
| Skewness | 1.0051813 |
| Sum | 33600213 |
| Variance | 201731.14 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 298 | 1508 | 2.3% |
| 1431.23 | 1426 | 2.2% |
| 966.44 | 1192 | 1.8% |
| 1275.1 | 1126 | 1.7% |
| 192.34 | 1041 | 1.6% |
| 1627.84 | 1035 | 1.6% |
| 157.76 | 988 | 1.5% |
| 1084.61 | 975 | 1.5% |
| 181.44 | 893 | 1.4% |
| 412.03 | 892 | 1.4% |
| Other values (1052) | 54165 |
| Value | Count | Frequency (%) |
| 0 | 255 | |
| 0.3929 | 150 | |
| 0.4 | 21 | < 0.1% |
| 0.405 | 25 | < 0.1% |
| 0.41 | 10 | < 0.1% |
| 0.445 | 6 | < 0.1% |
| 0.52 | 1 | < 0.1% |
| 0.61 | 4 | < 0.1% |
| 1.6236 | 2 | < 0.1% |
| 1.8711 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 2760.7 | 12 | < 0.1% |
| 2291.4 | 7 | < 0.1% |
| 2267 | 10 | < 0.1% |
| 1975 | 113 | |
| 1920 | 61 | |
| 1880 | 19 | < 0.1% |
| 1759.4 | 45 | 0.1% |
| 1731.4 | 35 | 0.1% |
| 1691.4 | 12 | < 0.1% |
| 1688.13 | 150 |
Order Number
Real number (ℝ)
| Distinct | 17769 |
|---|---|
| Distinct (%) | 27.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 180567.61 |
| Minimum | 100838 |
|---|---|
| Maximum | 321532 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 100838 |
|---|---|
| 5-th percentile | 103465 |
| Q1 | 115281 |
| median | 203695 |
| Q3 | 218576 |
| 95-th percentile | 319116 |
| Maximum | 321532 |
| Range | 220694 |
| Interquartile range (IQR) | 103295 |
Descriptive statistics
| Standard deviation | 67612.239 |
|---|---|
| Coefficient of variation (CV) | 0.37444278 |
| Kurtosis | -0.63225366 |
| Mean | 180567.61 |
| Median Absolute Deviation (MAD) | 80306 |
| Skewness | 0.52670753 |
| Sum | 1.1780411 × 1010 |
| Variance | 4.5714148 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 210770 | 126 | 0.2% |
| 222244 | 126 | 0.2% |
| 110770 | 124 | 0.2% |
| 122244 | 124 | 0.2% |
| 205051 | 121 | 0.2% |
| 105051 | 118 | 0.2% |
| 320895 | 118 | 0.2% |
| 212870 | 117 | 0.2% |
| 220895 | 116 | 0.2% |
| 120895 | 115 | 0.2% |
| Other values (17759) | 64036 |
| Value | Count | Frequency (%) |
| 100838 | 1 | < 0.1% |
| 100879 | 1 | < 0.1% |
| 100880 | 1 | < 0.1% |
| 100881 | 1 | < 0.1% |
| 100882 | 3 | |
| 100883 | 3 | |
| 100884 | 3 | |
| 100888 | 1 | < 0.1% |
| 100889 | 1 | < 0.1% |
| 100890 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 321532 | 5 | < 0.1% |
| 321528 | 11 | |
| 321519 | 1 | < 0.1% |
| 321509 | 3 | < 0.1% |
| 321504 | 1 | < 0.1% |
| 321500 | 1 | < 0.1% |
| 321496 | 1 | < 0.1% |
| 321489 | 1 | < 0.1% |
| 321483 | 15 | |
| 321482 | 1 | < 0.1% |
Promised Delivery Date
Categorical
| Distinct | 590 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| 27/06/2017 | 309 |
|---|---|
| 11/01/2017 | 305 |
| 09/07/2019 | 303 |
| 17/11/2017 | 273 |
| 29/11/2019 | 264 |
| Other values (585) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 652410 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 14/07/2017 |
|---|---|
| 2nd row | 16/10/2017 |
| 3rd row | 28/05/2017 |
| 4th row | 03/09/2017 |
| 5th row | 18/06/2017 |
Common Values
| Value | Count | Frequency (%) |
| 27/06/2017 | 309 | 0.5% |
| 11/01/2017 | 305 | 0.5% |
| 09/07/2019 | 303 | 0.5% |
| 17/11/2017 | 273 | 0.4% |
| 29/11/2019 | 264 | 0.4% |
| 18/06/2017 | 248 | 0.4% |
| 21/06/2017 | 238 | 0.4% |
| 30/06/2019 | 235 | 0.4% |
| 03/07/2019 | 231 | 0.4% |
| 10/01/2017 | 231 | 0.4% |
| Other values (580) | 62604 |
Length
| Value | Count | Frequency (%) |
| 27/06/2017 | 309 | 0.5% |
| 11/01/2017 | 305 | 0.5% |
| 09/07/2019 | 303 | 0.5% |
| 17/11/2017 | 273 | 0.4% |
| 29/11/2019 | 264 | 0.4% |
| 18/06/2017 | 248 | 0.4% |
| 21/06/2017 | 238 | 0.4% |
| 30/06/2019 | 235 | 0.4% |
| 03/07/2019 | 231 | 0.4% |
| 10/01/2017 | 231 | 0.4% |
| Other values (580) | 62604 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 144423 | |
| / | 130482 | |
| 1 | 122077 | |
| 2 | 105615 | |
| 7 | 41965 | 6.4% |
| 9 | 40897 | 6.3% |
| 8 | 18432 | 2.8% |
| 3 | 16342 | 2.5% |
| 6 | 11308 | 1.7% |
| 5 | 11164 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 521928 | |
| Other Punctuation | 130482 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 144423 | |
| 1 | 122077 | |
| 2 | 105615 | |
| 7 | 41965 | 8.0% |
| 9 | 40897 | 7.8% |
| 8 | 18432 | 3.5% |
| 3 | 16342 | 3.1% |
| 6 | 11308 | 2.2% |
| 5 | 11164 | 2.1% |
| 4 | 9705 | 1.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 130482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 652410 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 144423 | |
| / | 130482 | |
| 1 | 122077 | |
| 2 | 105615 | |
| 7 | 41965 | 6.4% |
| 9 | 40897 | 6.3% |
| 8 | 18432 | 2.8% |
| 3 | 16342 | 2.5% |
| 6 | 11308 | 1.7% |
| 5 | 11164 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 652410 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 144423 | |
| / | 130482 | |
| 1 | 122077 | |
| 2 | 105615 | |
| 7 | 41965 | 6.4% |
| 9 | 40897 | 6.3% |
| 8 | 18432 | 2.8% |
| 3 | 16342 | 2.5% |
| 6 | 11308 | 1.7% |
| 5 | 11164 | 1.7% |
Sales Amount
Real number (ℝ)
| Distinct | 17866 |
|---|---|
| Distinct (%) | 27.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2853.1211 |
| Minimum | 200.01 |
|---|---|
| Maximum | 555376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 200.01 |
|---|---|
| 5-th percentile | 215.78 |
| Q1 | 308.31 |
| median | 553.94 |
| Q3 | 1279.75 |
| 95-th percentile | 8795.9 |
| Maximum | 555376 |
| Range | 555175.99 |
| Interquartile range (IQR) | 971.44 |
Descriptive statistics
| Standard deviation | 15169.021 |
|---|---|
| Coefficient of variation (CV) | 5.3166412 |
| Kurtosis | 478.61708 |
| Mean | 2853.1211 |
| Median Absolute Deviation (MAD) | 292.92 |
| Skewness | 18.572946 |
| Sum | 1.8614047 × 108 |
| Variance | 2.3009919 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 784.97 | 115 | 0.2% |
| 817.68 | 115 | 0.2% |
| 294.72 | 110 | 0.2% |
| 307 | 104 | 0.2% |
| 597.14 | 102 | 0.2% |
| 622.02 | 101 | 0.2% |
| 824.39 | 100 | 0.2% |
| 791.41 | 99 | 0.2% |
| 401.16 | 95 | 0.1% |
| 204.66 | 92 | 0.1% |
| Other values (17856) | 64208 |
| Value | Count | Frequency (%) |
| 200.01 | 6 | |
| 200.06 | 6 | |
| 200.08 | 1 | < 0.1% |
| 200.14 | 3 | |
| 200.15 | 5 | |
| 200.19 | 7 | |
| 200.21 | 1 | < 0.1% |
| 200.3 | 3 | |
| 200.36 | 1 | < 0.1% |
| 200.37 | 6 |
| Value | Count | Frequency (%) |
| 555376 | 1 | < 0.1% |
| 539200 | 5 | |
| 517632 | 5 | |
| 472069.6 | 2 | < 0.1% |
| 458320 | 5 | |
| 439987.2 | 5 | |
| 310156.07 | 1 | < 0.1% |
| 301122.4 | 2 | < 0.1% |
| 297240 | 1 | < 0.1% |
| 289077.5 | 2 | < 0.1% |
Sales Amount Based on List Price
Real number (ℝ)
| Distinct | 4060 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4710.432 |
| Minimum | 0 |
|---|---|
| Maximum | 632610.16 |
| Zeros | 255 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 391.14 |
| Q1 | 561.04 |
| median | 999.75 |
| Q3 | 2321.4 |
| 95-th percentile | 16425.12 |
| Maximum | 632610.16 |
| Range | 632610.16 |
| Interquartile range (IQR) | 1760.36 |
Descriptive statistics
| Standard deviation | 20702.61 |
|---|---|
| Coefficient of variation (CV) | 4.3950554 |
| Kurtosis | 278.54884 |
| Mean | 4710.432 |
| Median Absolute Deviation (MAD) | 526.47 |
| Skewness | 14.07067 |
| Sum | 3.0731329 × 108 |
| Variance | 4.2859804 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1431.23 | 590 | 0.9% |
| 1627.84 | 530 | 0.8% |
| 803.86 | 498 | 0.8% |
| 596 | 448 | 0.7% |
| 1254.1899 | 418 | 0.6% |
| 966.44 | 376 | 0.6% |
| 439.7 | 372 | 0.6% |
| 507.75 | 363 | 0.6% |
| 767.75 | 348 | 0.5% |
| 939.57 | 343 | 0.5% |
| Other values (4050) | 60955 |
| Value | Count | Frequency (%) |
| 0 | 255 | |
| 194 | 2 | < 0.1% |
| 195.61 | 1 | < 0.1% |
| 198.396 | 1 | < 0.1% |
| 198.63 | 1 | < 0.1% |
| 200.7 | 8 | < 0.1% |
| 200.8 | 1 | < 0.1% |
| 201.69 | 3 | < 0.1% |
| 202.14 | 1 | < 0.1% |
| 202.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 632610.16 | 5 | |
| 624453.75 | 2 | < 0.1% |
| 539200 | 11 | |
| 458320 | 12 | |
| 391924.7232 | 5 | |
| 387395 | 8 | |
| 348655.5 | 2 | < 0.1% |
| 332196.405 | 2 | < 0.1% |
| 330708.3792 | 5 | |
| 310273.7392 | 2 | < 0.1% |
Sales Cost Amount
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5513 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1662.0231 |
| Minimum | 0 |
|---|---|
| Maximum | 366576 |
| Zeros | 308 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 85.36 |
| Q1 | 167.81 |
| median | 304.58 |
| Q3 | 688.55 |
| 95-th percentile | 4946.11 |
| Maximum | 366576 |
| Range | 366576 |
| Interquartile range (IQR) | 520.74 |
Descriptive statistics
| Standard deviation | 9559.3969 |
|---|---|
| Coefficient of variation (CV) | 5.7516633 |
| Kurtosis | 613.9028 |
| Mean | 1662.0231 |
| Median Absolute Deviation (MAD) | 171.17 |
| Skewness | 21.004615 |
| Sum | 1.0843205 × 108 |
| Variance | 91382069 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 449.69 | 534 | 0.8% |
| 475.75 | 457 | 0.7% |
| 0 | 308 | 0.5% |
| 134.67 | 305 | 0.5% |
| 162.89 | 289 | 0.4% |
| 205.72 | 253 | 0.4% |
| 159.14 | 242 | 0.4% |
| 16718.08 | 234 | 0.4% |
| 546.44 | 231 | 0.4% |
| 344.28 | 229 | 0.4% |
| Other values (5503) | 62159 |
| Value | Count | Frequency (%) |
| 0 | 308 | |
| 12.97 | 2 | < 0.1% |
| 19.55 | 4 | < 0.1% |
| 20.8 | 6 | < 0.1% |
| 26 | 1 | < 0.1% |
| 31.19 | 4 | < 0.1% |
| 33.97 | 3 | < 0.1% |
| 35.48 | 2 | < 0.1% |
| 35.54 | 5 | < 0.1% |
| 36.03 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 366576 | 7 | < 0.1% |
| 353292.8 | 4 | < 0.1% |
| 311589.6 | 12 | < 0.1% |
| 185048.85 | 2 | < 0.1% |
| 161446.35 | 5 | < 0.1% |
| 157412.85 | 2 | < 0.1% |
| 153635.03 | 5 | < 0.1% |
| 146630.4 | 4 | < 0.1% |
| 141265.56 | 36 | |
| 137736.24 | 4 | < 0.1% |
Sales Margin Amount
Real number (ℝ)
| Distinct | 21266 |
|---|---|
| Distinct (%) | 32.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1191.098 |
| Minimum | -3932.93 |
|---|---|
| Maximum | 188800 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 576 |
| Negative (%) | 0.9% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | -3932.93 |
|---|---|
| 5-th percentile | 61.54 |
| Q1 | 129.89 |
| median | 246.48 |
| Q3 | 578.22 |
| 95-th percentile | 3825.85 |
| Maximum | 188800 |
| Range | 192732.93 |
| Interquartile range (IQR) | 448.33 |
Descriptive statistics
| Standard deviation | 5862.5666 |
|---|---|
| Coefficient of variation (CV) | 4.9219851 |
| Kurtosis | 324.74032 |
| Mean | 1191.098 |
| Median Absolute Deviation (MAD) | 140.23 |
| Skewness | 15.567055 |
| Sum | 77708425 |
| Variance | 34369688 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 374.7 | 93 | 0.1% |
| 5317.17 | 88 | 0.1% |
| 6235.31 | 87 | 0.1% |
| 341.72 | 84 | 0.1% |
| 15.32 | 69 | 0.1% |
| 37.08 | 67 | 0.1% |
| 52.8 | 67 | 0.1% |
| 431.88 | 64 | 0.1% |
| 464.59 | 64 | 0.1% |
| 24.53 | 63 | 0.1% |
| Other values (21256) | 64495 |
| Value | Count | Frequency (%) |
| -3932.93 | 1 | |
| -3764.4 | 2 | |
| -3673.68 | 2 | |
| -3608.81 | 1 | |
| -3414.01 | 2 | |
| -3132.65 | 2 | |
| -2533.97 | 2 | |
| -2508.21 | 2 | |
| -2488.89 | 1 | |
| -2103.04 | 2 |
| Value | Count | Frequency (%) |
| 188800 | 1 | < 0.1% |
| 185907.2 | 2 | |
| 172624 | 3 | |
| 164339.2 | 2 | |
| 160480 | 2 | |
| 156773.4 | 1 | < 0.1% |
| 156521.04 | 1 | < 0.1% |
| 151056 | 3 | |
| 148401.6 | 3 | |
| 147487.37 | 2 |
Sales Price
Real number (ℝ)
| Distinct | 14757 |
|---|---|
| Distinct (%) | 22.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283.25028 |
| Minimum | 0.33734118 |
|---|---|
| Maximum | 6035 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 0.33734118 |
|---|---|
| 5-th percentile | 22.425556 |
| Q1 | 100.03 |
| median | 183.28286 |
| Q3 | 448.22 |
| 95-th percentile | 787.12 |
| Maximum | 6035 |
| Range | 6034.6627 |
| Interquartile range (IQR) | 348.19 |
Descriptive statistics
| Standard deviation | 250.44861 |
|---|---|
| Coefficient of variation (CV) | 0.88419546 |
| Kurtosis | 5.8888259 |
| Mean | 283.25028 |
| Median Absolute Deviation (MAD) | 116.23352 |
| Skewness | 1.3311756 |
| Sum | 18479532 |
| Variance | 62724.509 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 140.43 | 191 | 0.3% |
| 817.68 | 189 | 0.3% |
| 133.41 | 181 | 0.3% |
| 824.39 | 138 | 0.2% |
| 783.17 | 138 | 0.2% |
| 23.47 | 136 | 0.2% |
| 82.87333333 | 125 | 0.2% |
| 230.25 | 120 | 0.2% |
| 221.04 | 120 | 0.2% |
| 230.98 | 120 | 0.2% |
| Other values (14747) | 63783 |
| Value | Count | Frequency (%) |
| 0.337341176 | 2 | < 0.1% |
| 0.3514 | 1 | < 0.1% |
| 0.361941176 | 1 | < 0.1% |
| 0.37718 | 67 | |
| 0.384 | 9 | < 0.1% |
| 0.3888 | 12 | < 0.1% |
| 0.3929 | 67 | |
| 0.3936 | 5 | < 0.1% |
| 0.4 | 9 | < 0.1% |
| 0.40469 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 6035 | 1 | |
| 3748 | 1 | |
| 3009.86 | 1 | |
| 3003.41 | 1 | |
| 2823 | 1 | |
| 2753.32 | 1 | |
| 2540.17 | 1 | |
| 2360.1 | 1 | |
| 2314.39 | 1 | |
| 1989.61 | 1 |
Sales Quantity
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 279 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.106712 |
| Minimum | 1 |
|---|---|
| Maximum | 16000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 8 |
| 95-th percentile | 86 |
| Maximum | 16000 |
| Range | 15999 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 429.79373 |
|---|---|
| Coefficient of variation (CV) | 9.5283764 |
| Kurtosis | 649.36123 |
| Mean | 45.106712 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 23.000674 |
| Sum | 2942807 |
| Variance | 184722.65 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 15226 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 10 | 2596 | 4.0% |
| 8 | 1460 | 2.2% |
| 12 | 1314 | 2.0% |
| 20 | 1034 | 1.6% |
| Other values (269) | 11536 |
| Value | Count | Frequency (%) |
| 1 | 15226 | |
| 2 | 13466 | |
| 3 | 7056 | |
| 4 | 4973 | 7.6% |
| 5 | 3519 | 5.4% |
| 6 | 3061 | 4.7% |
| 7 | 711 | 1.1% |
| 8 | 1460 | 2.2% |
| 9 | 453 | 0.7% |
| 10 | 2596 | 4.0% |
| Value | Count | Frequency (%) |
| 16000 | 11 | < 0.1% |
| 13600 | 12 | < 0.1% |
| 9504 | 7 | < 0.1% |
| 8316 | 40 | |
| 7128 | 21 | |
| 7126 | 2 | < 0.1% |
| 6480 | 2 | < 0.1% |
| 6400 | 4 | < 0.1% |
| 5834 | 4 | < 0.1% |
| 4752 | 13 | < 0.1% |
Sales Rep
Real number (ℝ)
| Distinct | 64 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 137.42142 |
| Minimum | 103 |
|---|---|
| Maximum | 185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 509.8 KiB |
Quantile statistics
| Minimum | 103 |
|---|---|
| 5-th percentile | 104 |
| Q1 | 113 |
| median | 134 |
| Q3 | 160 |
| 95-th percentile | 180 |
| Maximum | 185 |
| Range | 82 |
| Interquartile range (IQR) | 47 |
Descriptive statistics
| Standard deviation | 26.644271 |
|---|---|
| Coefficient of variation (CV) | 0.19388732 |
| Kurtosis | -1.3014508 |
| Mean | 137.42142 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.35067578 |
| Sum | 8965511 |
| Variance | 709.91716 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 108 | 6225 | 9.5% |
| 180 | 4426 | 6.8% |
| 143 | 2926 | 4.5% |
| 117 | 2440 | 3.7% |
| 103 | 2162 | 3.3% |
| 104 | 2065 | 3.2% |
| 134 | 2032 | 3.1% |
| 115 | 1986 | 3.0% |
| 125 | 1967 | 3.0% |
| 157 | 1743 | 2.7% |
| Other values (54) | 37269 |
| Value | Count | Frequency (%) |
| 103 | 2162 | 3.3% |
| 104 | 2065 | 3.2% |
| 105 | 1184 | 1.8% |
| 107 | 1303 | 2.0% |
| 108 | 6225 | |
| 109 | 1137 | 1.7% |
| 110 | 594 | 0.9% |
| 111 | 542 | 0.8% |
| 112 | 486 | 0.7% |
| 113 | 1417 | 2.2% |
| Value | Count | Frequency (%) |
| 185 | 537 | 0.8% |
| 184 | 228 | 0.3% |
| 183 | 326 | 0.5% |
| 182 | 808 | 1.2% |
| 181 | 792 | 1.2% |
| 180 | 4426 | |
| 179 | 875 | 1.3% |
| 176 | 1081 | 1.7% |
| 175 | 1321 | 2.0% |
| 173 | 794 | 1.2% |
U/M
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 509.8 KiB |
| EA | |
|---|---|
| SE | 5628 |
| PR | 659 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 130482 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EA |
|---|---|
| 2nd row | EA |
| 3rd row | SE |
| 4th row | EA |
| 5th row | EA |
Common Values
| Value | Count | Frequency (%) |
| EA | 58954 | |
| SE | 5628 | 8.6% |
| PR | 659 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ea | 58954 | |
| se | 5628 | 8.6% |
| pr | 659 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 64582 | |
| A | 58954 | |
| S | 5628 | 4.3% |
| P | 659 | 0.5% |
| R | 659 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 130482 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 64582 | |
| A | 58954 | |
| S | 5628 | 4.3% |
| P | 659 | 0.5% |
| R | 659 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 130482 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 64582 | |
| A | 58954 | |
| S | 5628 | 4.3% |
| P | 659 | 0.5% |
| R | 659 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 130482 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 64582 | |
| A | 58954 | |
| S | 5628 | 4.3% |
| P | 659 | 0.5% |
| R | 659 | 0.5% |
| Unnamed: 0 | CustKey | Discount Amount | Invoice Number | Line Number | List Price | Order Number | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Sales Rep | Item Class | U/M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | 0.009 | 0.016 | 0.010 | 0.028 | -0.007 | 0.279 | 0.017 | 0.017 | 0.014 | 0.027 | -0.007 | 0.024 | -0.001 | 0.009 | 0.026 |
| CustKey | 0.009 | 1.000 | -0.016 | -0.101 | 0.007 | -0.008 | 0.081 | 0.015 | 0.006 | 0.019 | 0.011 | -0.004 | 0.011 | -0.161 | 0.012 | 0.053 |
| Discount Amount | 0.016 | -0.016 | 1.000 | 0.078 | 0.001 | 0.437 | -0.039 | 0.824 | 0.896 | 0.783 | 0.733 | 0.369 | 0.379 | -0.045 | 0.000 | 0.000 |
| Invoice Number | 0.010 | -0.101 | 0.078 | 1.000 | 0.012 | 0.014 | -0.481 | -0.002 | 0.031 | 0.023 | -0.027 | -0.019 | 0.012 | 0.007 | 0.000 | 0.016 |
| Line Number | 0.028 | 0.007 | 0.001 | 0.012 | 1.000 | -0.042 | 0.015 | -0.171 | -0.113 | -0.130 | -0.202 | -0.075 | -0.053 | -0.094 | 0.000 | 0.076 |
| List Price | -0.007 | -0.008 | 0.437 | 0.014 | -0.042 | 1.000 | 0.003 | 0.356 | 0.381 | 0.388 | 0.287 | 0.980 | -0.544 | 0.015 | 0.013 | 0.189 |
| Order Number | 0.279 | 0.081 | -0.039 | -0.481 | 0.015 | 0.003 | 1.000 | 0.000 | -0.016 | -0.027 | 0.037 | 0.020 | -0.015 | 0.010 | 0.000 | 0.009 |
| Sales Amount | 0.017 | 0.015 | 0.824 | -0.002 | -0.171 | 0.356 | 0.000 | 1.000 | 0.968 | 0.932 | 0.890 | 0.358 | 0.484 | 0.011 | 0.000 | 0.009 |
| Sales Amount Based on List Price | 0.017 | 0.006 | 0.896 | 0.031 | -0.113 | 0.381 | -0.016 | 0.968 | 1.000 | 0.913 | 0.860 | 0.347 | 0.476 | -0.010 | 0.000 | 0.012 |
| Sales Cost Amount | 0.014 | 0.019 | 0.783 | 0.023 | -0.130 | 0.388 | -0.027 | 0.932 | 0.913 | 1.000 | 0.708 | 0.375 | 0.422 | 0.001 | 0.000 | 0.011 |
| Sales Margin Amount | 0.027 | 0.011 | 0.733 | -0.027 | -0.202 | 0.287 | 0.037 | 0.890 | 0.860 | 0.708 | 1.000 | 0.300 | 0.475 | 0.021 | 0.000 | 0.012 |
| Sales Price | -0.007 | -0.004 | 0.369 | -0.019 | -0.075 | 0.980 | 0.020 | 0.358 | 0.347 | 0.375 | 0.300 | 1.000 | -0.567 | 0.037 | 0.000 | 0.094 |
| Sales Quantity | 0.024 | 0.011 | 0.379 | 0.012 | -0.053 | -0.544 | -0.015 | 0.484 | 0.476 | 0.422 | 0.475 | -0.567 | 1.000 | -0.032 | 0.000 | 0.007 |
| Sales Rep | -0.001 | -0.161 | -0.045 | 0.007 | -0.094 | 0.015 | 0.010 | 0.011 | -0.010 | 0.001 | 0.021 | 0.037 | -0.032 | 1.000 | 0.021 | 0.077 |
| Item Class | 0.009 | 0.012 | 0.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.021 | 1.000 | 0.000 |
| U/M | 0.026 | 0.053 | 0.000 | 0.016 | 0.076 | 0.189 | 0.009 | 0.009 | 0.012 | 0.011 | 0.012 | 0.094 | 0.007 | 0.077 | 0.000 | 1.000 |
| Unnamed: 0 | CustKey | DateKey | Discount Amount | Invoice Date | Invoice Number | Item Class | Item Number | Item | Line Number | List Price | Order Number | Promised Delivery Date | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Sales Rep | U/M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 10002220 | 14/07/2017 | 368.7900 | 14/07/2017 | 100233 | P01 | 20910 | Moms Sliced Turkey | 1000 | 824.9600 | 200245 | 14/07/2017 | 456.17 | 824.9600 | 0.0 | 456.17 | 456.170000 | 1 | 127 | EA |
| 1 | 2 | 10002220 | 17/10/2017 | 109.7300 | 17/10/2017 | 116165 | P01 | 38076 | Cutting Edge Foot-Long Hot Dogs | 1000 | 548.6600 | 213157 | 16/10/2017 | 438.93 | 548.6600 | 0.0 | 438.93 | 438.930000 | 1 | 127 | EA |
| 2 | 4 | 10004516 | 27/05/2017 | 96627.9400 | 27/05/2017 | 103341 | P01 | 60776 | High Top Sweet Onion | 1000 | 408.5200 | 203785 | 28/05/2017 | 89248.66 | 185876.6000 | 0.0 | 89248.66 | 196.150901 | 455 | 124 | SE |
| 3 | 6 | 10007866 | 03/09/2017 | 371.0140 | 03/09/2017 | 100403 | P01 | 20910 | Moms Sliced Turkey | 2000 | 795.3140 | 200436 | 03/09/2017 | 424.30 | 795.3140 | 0.0 | 424.30 | 424.300000 | 1 | 149 | EA |
| 4 | 7 | 10009356 | 18/06/2017 | 608.0800 | 18/06/2017 | 105481 | P01 | 62550 | Tell Tale Garlic | 29000 | 575.0000 | 205213 | 18/06/2017 | 541.92 | 1150.0000 | 0.0 | 541.92 | 270.960000 | 2 | 103 | EA |
| 5 | 8 | 10009356 | 18/06/2017 | 424.8000 | 18/06/2017 | 105481 | P01 | 60794 | High Top Walnuts | 18000 | 51.8800 | 205213 | 18/06/2017 | 353.40 | 778.2000 | 0.0 | 353.40 | 23.560000 | 15 | 103 | EA |
| 6 | 9 | 10009356 | 18/06/2017 | 13492.8000 | 18/06/2017 | 105481 | P01 | 36001 | Big Time Frozen Cheese Pizza | 9000 | 412.0300 | 205213 | 18/06/2017 | 11229.00 | 24721.8000 | 0.0 | 11229.00 | 187.150000 | 60 | 103 | EA |
| 7 | 10 | 10009356 | 18/06/2017 | 10481.1000 | 18/06/2017 | 105481 | P01 | 38076 | Cutting Edge Foot-Long Hot Dogs | 13000 | 548.6600 | 205213 | 18/06/2017 | 8722.00 | 19203.1000 | 0.0 | 8722.00 | 249.200000 | 35 | 103 | EA |
| 8 | 11 | 10009356 | 18/06/2017 | 404.1465 | 18/06/2017 | 105481 | P01 | 61484 | Super Creamy Peanut Butter | 37000 | 50.5051 | 205213 | 18/06/2017 | 353.43 | 757.5765 | 0.0 | 353.43 | 23.562000 | 15 | 103 | EA |
| 9 | 12 | 10009606 | 16/09/2017 | 1287.3476 | 16/09/2017 | 100445 | P01 | 17801 | Better Fancy Canned Sardines | 3000 | 1379.7938 | 200478 | 16/09/2017 | 1472.24 | 2759.5876 | 0.0 | 1472.24 | 736.120000 | 2 | 118 | EA |
| Unnamed: 0 | CustKey | DateKey | Discount Amount | Invoice Date | Invoice Number | Item Class | Item Number | Item | Line Number | List Price | Order Number | Promised Delivery Date | Sales Amount | Sales Amount Based on List Price | Sales Cost Amount | Sales Margin Amount | Sales Price | Sales Quantity | Sales Rep | U/M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65231 | 65272 | 10017638 | 21/03/2018 | 596.32 | 21/03/2018 | 226497 | P01 | 30500 | Blue Label Canned Beets | 100000 | 634.11 | 320895 | 21/03/2018 | 671.90 | 1268.22 | 544.11 | 127.79 | 335.950000 | 2 | 180 | EA |
| 65232 | 65273 | 10017638 | 21/03/2018 | 4654.76 | 21/03/2018 | 226498 | P01 | 20910 | Moms Sliced Turkey | 2000 | 824.96 | 320907 | 21/03/2018 | 5244.76 | 9899.52 | 3058.48 | 2186.28 | 437.063333 | 12 | 180 | EA |
| 65233 | 65274 | 10017638 | 21/03/2018 | 1582.78 | 21/03/2018 | 226497 | P01 | 38060 | Gorilla Strawberry Yogurt | 153000 | 187.01 | 320895 | 21/03/2018 | 1783.40 | 3366.18 | 768.23 | 1015.17 | 99.077778 | 18 | 180 | EA |
| 65234 | 65275 | 10017638 | 21/03/2018 | 1095.70 | 21/03/2018 | 226497 | P01 | 38007 | Gorilla Jack Cheese | 150000 | 1103.00 | 320895 | 21/03/2018 | 1110.30 | 2206.00 | 844.55 | 265.75 | 555.150000 | 2 | 180 | EA |
| 65235 | 65276 | 10017638 | 21/03/2018 | 277.61 | 21/03/2018 | 226497 | P01 | 2040 | Blue Label Fancy Canned Oysters | 18000 | 14.76 | 320895 | 21/03/2018 | 312.79 | 590.40 | 268.40 | 44.39 | 7.819750 | 40 | 180 | EA |
| 65236 | 65277 | 10017638 | 21/03/2018 | 505.78 | 21/03/2018 | 226497 | P01 | 13447 | High Top Oranges | 8000 | 119.52 | 320895 | 21/03/2018 | 569.90 | 1075.68 | 239.95 | 329.95 | 63.322222 | 9 | 180 | EA |
| 65237 | 65278 | 10017638 | 21/03/2018 | 410.75 | 21/03/2018 | 226497 | P01 | 25906 | Landslide White Sugar | 38000 | 436.78 | 320895 | 21/03/2018 | 462.81 | 873.56 | 423.55 | 39.26 | 231.405000 | 2 | 180 | EA |
| 65238 | 65279 | 10017638 | 21/03/2018 | 876.16 | 21/03/2018 | 226497 | P01 | 61856 | Moms Potato Salad | 227001 | 232.92 | 320895 | 21/03/2018 | 987.20 | 1863.36 | 574.00 | 413.20 | 123.400000 | 8 | 180 | EA |
| 65239 | 65280 | 10017638 | 21/03/2018 | 24226.77 | 21/03/2018 | 226498 | P01 | 17801 | Better Fancy Canned Sardines | 1000 | 1431.23 | 320907 | 21/03/2018 | 27297.51 | 51524.28 | 16188.90 | 11108.61 | 758.264167 | 36 | 180 | EA |
| 65240 | 65281 | 10017638 | 21/03/2018 | 24479.26 | 21/03/2018 | 226498 | P01 | 27550 | Imagine Popsicles | 4000 | 1084.61 | 320907 | 21/03/2018 | 27582.02 | 52061.28 | 14234.22 | 13347.80 | 574.625417 | 48 | 180 | EA |